Columns
Grants
Dependencies
Details
Triggers
Errors
Columns
Grants
Dependencies
Details
Triggers
Errors
COLUMN_NAME | DATA_TYPE | NULLABLE | DATA_DEFAULT | COLUMN_ID | COMMENTS | INSERTABLE | UPDATABLE | DELETABLE |
---|---|---|---|---|---|---|---|---|
OBJ | VARCHAR2(20) | Yes | null | 1 | null | NO | NO | NO |
ID | VARCHAR2(100) | Yes | null | 2 | null | NO | NO | NO |
OBJ_TYPE | VARCHAR2(100) | Yes | null | 3 | null | NO | NO | NO |
DISPOSITION | VARCHAR2(4000) | Yes | null | 4 | null | NO | NO | NO |
LEAD | VARCHAR2(400) | Yes | null | 5 | null | NO | NO | NO |
LEAD_OBJ | VARCHAR2(20) | Yes | null | 6 | null | NO | NO | NO |
STATUS | VARCHAR2(100) | Yes | null | 7 | null | NO | NO | NO |
SUPPORT_PERSONNEL | VARCHAR2(400) | Yes | null | 8 | null | NO | NO | NO |
SUPPORT_PERS_OBJ | VARCHAR2(20) | Yes | null | 9 | null | NO | NO | NO |
CREATED_ON | DATE | Yes | null | 10 | null | NO | NO | NO |
PRIVILEGE | GRANTEE | GRANTABLE | GRANTOR | OBJECT_NAME |
---|
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_INTAKE_ASSOC_FILES | VIEW | QART | V_ALL_FILES_INTAKE_ASSOC | VIEW |
References
OWNER | NAME | TYPE | REFERENCED_OWNER | REFERENCED_NAME | REFERENCED_TYPE |
---|---|---|---|---|---|
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | V_SIIC_THREAT_INV | VIEW |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | MV_ACM_OBJ | TABLE |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | MV_ACM_OBJ_TYPE | TABLE |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | V_CURR_OBJ_LEAD_PERS | VIEW |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | V_OBJ_STATUS_HISTORY | VIEW |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | MV_F_INFORMATION_REF | TABLE |
QART | V_ALL_FILES_INTAKE_ASSOC | VIEW | QART | V_CURR_OBJ_SUPPORT_OFFICER | VIEW |
NAME | VALUE |
---|---|
CREATED | 23-OCT-24 |
LAST_DDL_TIME | 24-OCT-24 |
OWNER | QART |
VIEW_NAME | V_ALL_FILES_INTAKE_ASSOC |
TEXT_LENGTH | 1309 |
TEXT | SELECT OBJ, ID, OBJ_TYPE, DISPOSITION, LEAD, LEAD_OBJ, STATUS, SUPPORT_PERSONNEL, SUPPORT_PERS_OBJ, CREATED_ON FROM ( --Informational Investigation Select i.obj, i.ID, ot.display OBJ_TYPE, ir.display DISPOSITION, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, o.CREATED_ON from mv_f_information i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid left outer join v_curr_obj_lead_pers lp on i.obj = lp.obj inner join v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join mv_f_information_ref ir on i.disposition = ir.ref_key left outer join v_curr_obj_support_officer so on i.obj = so.obj UNION ALL --Threat Investigation select i.obj, i.id, ot.display OBJ_TYPE, i.final_disposition Disposition, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, i.CREATED_DATE from v_siic_threat_inv i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid left outer join v_curr_obj_lead_pers lp on i.obj = lp.obj inner join v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join v_curr_obj_support_officer so on i.obj = so.obj ) |
TEXT_VC | SELECT OBJ, ID, OBJ_TYPE, DISPOSITION, LEAD, LEAD_OBJ, STATUS, SUPPORT_PERSONNEL, SUPPORT_PERS_OBJ, CREATED_ON FROM ( --Informational Investigation Select i.obj, i.ID, ot.display OBJ_TYPE, ir.display DISPOSITION, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, o.CREATED_ON from mv_f_information i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid left outer join v_curr_obj_lead_pers lp on i.obj = lp.obj inner join v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join mv_f_information_ref ir on i.disposition = ir.ref_key left outer join v_curr_obj_support_officer so on i.obj = so.obj UNION ALL --Threat Investigation select i.obj, i.id, ot.display OBJ_TYPE, i.final_disposition Disposition, lp.sh_display LEAD, lp.sh_obj LEAD_OBJ, h.status, so.sh_display SUPPORT_PERSONNEL, so.sh_obj SUPPORT_PERS_OBJ, i.CREATED_DATE from v_siic_threat_inv i inner join mv_acm_obj o on i.obj = o.sid inner join mv_acm_obj_type ot on o.obj_type = ot.sid left outer join v_curr_obj_lead_pers lp on i.obj = lp.obj inner join v_obj_status_history h on i.obj = h.obj and h.completed_on is null left outer join v_curr_obj_support_officer so on i.obj = so.obj ) |
TYPE_TEXT_LENGTH | null |
TYPE_TEXT | null |
OID_TEXT_LENGTH | null |
OID_TEXT | null |
VIEW_TYPE_OWNER | null |
VIEW_TYPE | null |
SUPERVIEW_NAME | null |
EDITIONING_VIEW | N |
READ_ONLY | N |
CONTAINER_DATA | N |
BEQUEATH | DEFINER |
ORIGIN_CON_ID | 16 |
DEFAULT_COLLATION | USING_NLS_COMP |
CONTAINERS_DEFAULT | NO |
CONTAINER_MAP | NO |
EXTENDED_DATA_LINK | NO |
EXTENDED_DATA_LINK_MAP | NO |
HAS_SENSITIVE_COLUMN | NO |
ADMIT_NULL | NO |
PDB_LOCAL_ONLY | NO |
DUPLICATED | N |
SHARDED | N |
OWNER | TRIGGER_NAME | TRIGGER_TYPE | TRIGGERING_EVENT | STATUS | OBJECT_ID |
---|
ATTRIBUTE | Line:Position | TEXT |
---|